# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月17日
"""
import openpyxl

myBook=openpyxl.load_workbook('新书订购表.xlsx')
mySheet=myBook['新书订购表']
myRows=list(mySheet.values)[1:]
myList=[]
for myRow in myRows:
	myList+=[myRow[0]]

myList.sort(key=len,reverse=True)

while mySheet.max_row>1:
	mySheet.delete_rows(2)

for myRow in myList:
	mySheet.append([myRow])

myBook.save('结果表-新书订购表.xlsx')

